<html>
<head>
<title>::.::.::  APPMA  ||  Member List Admin  ::.::.::</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<!-- ImageReady Styles (index.psd) -->

<link href="css/styleinner.css" rel="stylesheet" type="text/css">

<link href="css/css_tab/samples.css" rel="stylesheet" type="text/css">
<link href="css/css_tab/SprySlidingPanels.css" rel="stylesheet" type="text/css">
<link href="css/css_tab/tab_style.css" rel="stylesheet" type="text/css">
<!-- End ImageReady Styles -->
<script src="java/SprySlidingPanels.js" type="text/javascript"></script>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_reloadPage(init) {  //reloads the window if Nav4 resized
  if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
    document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
  else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->



</script>

<style type="text/css">
<!--

#usefullinks {
	position:absolute;
	width:381px;
	height:94px;
	z-index:1;
	left: 38px;
	top: 30px;
}
-->
</style>
</head>
<body style="margin-top: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px;">
<!-- ImageReady Slices (index.psd) -->
<center><div id="Table_01">
	<div id="index-01">
	
	  <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="621" height="150">
        <param name="movie" value="flash/title.swf">
        <param name="quality" value="high">
        <embed src="flash/title.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="621" height="150"></embed>
      </object>
    </div>
	<div id="index-02">
		
	
			  <div id="contactlink" onClick="MM_goToURL('parent','contact.php');return document.MM_returnValue"></div>
	  <div id="feedback" onClick="MM_goToURL('parent','feedback.php');return document.MM_returnValue"></div>
	  <div id="sitemap" onClick="MM_goToURL('parent','sitemap.php');return document.MM_returnValue"></div>

<?php if(isset($_SESSION['SESS_MEMBER_ID'])) {
	echo '<div id="logout"><a href="logout.php">Logout</a></div>';
	}	  
	 ?> 
	
	

	  <div id="search">
	  <form action="search.php" method="get">
	  <td valign="middle" height="30px">
	  <input type="text" name="query" id="query" height="20px" size="35" action="include/js_suggest/suggest.php"></td>
	  <input type="text" name="search" value="1" style="display:none;">
	  <td valign="middle" height="30px">
	  <input type="submit" class="searchbtn" value=""></td>
	  </form>
	  </div>
	
	
	
	</div>
	<div id="index-03">
		
		
				<?php
				$File = "nav.html";
				$fh = fopen($File, 'r');
				$List = fread($fh, filesize($File));
				fclose($fh);
				echo $List;
			?> 
		
		
	</div>
	<div id="index-04">
    <?php
				$File = "menuleft.html";
				$fh = fopen($File, 'r');
				$List = fread($fh, filesize($File));
				fclose($fh);
				echo $List;
			?> 
		
    
    
   
    </div>
	<div id="index-09">
	  <div id="platinum">

<?php
$con = mysql_connect("localhost","appma" ,"database");
mysql_select_db("162_appma", $con);
$sql="SELECT link FROM sponsor WHERE sponsor='platinum'";
if (!$sql)
	  {
	  die('Could Not Complete Please Try Again Later: ' );
	  }
$result=mysql_query($sql);
$row = mysql_fetch_array($result);
?>
<a href="<?php echo $row['link']; ?>" target="_blank">
<img src="uploader/sponsor/platinum.jpg"></a>

	  </div>
	</div>
	<div id="index-13">
	  <div id="gold">
	  
	<?php
$con = mysql_connect("localhost","appma" ,"database");
mysql_select_db("162_appma", $con);
$sql="SELECT link FROM sponsor WHERE sponsor='gold'";
if (!$sql)
	  {
	  die('Could Not Complete Please Try Again Later: ' );
	  }
$result=mysql_query($sql);
$row = mysql_fetch_array($result);
?>
	  <a href="<?php echo $row['link']; ?>" target="_blank"><img src="uploader/sponsor/gold.jpg"></a>
	  
	  </div>
    
    </div>
	<div id="index-16">
	  <div id="contact">
	    <p>HEAD OFFICE: Room #104,Azeem Chamber,<br>
		Hasan Ali Effendi Road, Karachi-74200.<br>
	      Phone: 021-32621041,<br>
	      Fax: 021-32210385,<br>
	      Email: paperassociation@homail.com<br>
        URL: www.appma.com.pk</p>
      </div>

	</div>
    <div id="mid">
    <div id="text">


  <table cellpadding="0" cellspacing="0">
    <tr> 
      <td>
		</td>
				
          
      <div> 
        <div align="left"><font size="+2" face="Lucida Calligraphy">Members List</font></div>
      </div>

      <td>


<?php

  $search = $_POST["search"];
  
  //connect  to the database

$con = mysql_connect("localhost","appma" ,"database");
		
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

	mysql_select_db("162_appma", $con);

	  $sql="SELECT * FROM members ORDER BY regno";
  if (!$sql)
		  {
		  die('Could Not Complete Please Try Again Later: ' );
		  }

  //-run  the query against the mysql query function
 		 $result=mysql_query($sql);
  //-create  while loop and loop through result set
    		echo "<table border='2'>
		<tr>
		<th>EDIT</th>
		<th>REG.No.</th>
		<th>Name</th>
		<th>Firm Name</th>
		</tr>";
		
		while($row = mysql_fetch_array($result))
		  {
		  echo "<tr>";
		  echo "<td><a href='delete_member.php?regno=" . $row['regno'] . "' target='_self'>DEL</a>
		  			<a href='Form_Member_Update.php?regno=" . $row['regno'] . "' target='_self'>EDIT</a>
				</td>";
		  echo "<td>" . $row['regno'] . "</td>";
		  echo "<td>" . $row['name'] . "</td>";
		  echo "<td>" . $row['firmname'] . "</td>";
		  echo "</tr>";
		  }
		echo "</table>";  

  //-display the result of the array
  		$DBresult = mysql_query($result, $con);

?>

</td>
		  				  <td> 


    </tr>
	
    <tr>
      <td width="50">

	  </td>
    </tr>
  </table>


 </div>
	<div id="bottom">
		<img src="images/index_18.jpg" width="1003" height="42" alt="">	</div>
</div>
</div>
</center>
<!-- End ImageReady Slices -->
</body>
</html>